package com.lizheng.yunservice.travel.mapper;

import com.lizheng.yunservice.travel.doamin.VtpFileResources;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface VtpAppFileResourceMapper {

    // 根据景区ID和资源类型查询资源
    @Select("SELECT * FROM vtp_file_resources " +
            "WHERE record_id = #{scenicId} AND resource_type = #{type} AND delete_flag = 0")
    List<VtpFileResources> selectByScenicIdAndType(
            @Param("scenicId") Long scenicId,
            @Param("type") Integer type);
}